Labels:text | screenshot | font | number | black and white OCR: Package Name Description DBMS ALERT Provides support for notification of database events on an asynchronous basis. You register a process with an alert and then wait for a signal from that alert. You will usually do this from within a database trigger. DBMS DOL Programmatic access to some of the SOL DDL statements, such as ALTER_COMPILE and ANALYZE_OBJECT. DBMS_JOB Allows you to submit and manage regularly scheduled jobs for execution inside the database. Il your cron tables in UNIX are simply executing stored procedures, you can use DOMS_JOB instead (fully supported as of PL/SQL Release 2.2). DBMS LOCK Create your own user locks in the database using the Oracle Lock Management facility. Use it to detect whether cominits have been performed in your session, and to pause a PL/SQL program. DBMS_OUTPUT Displays output from PL/SQL programs to the terminal, Functions as a crude debugger and reporting mechanism for PL/SQL. DBMS PIPE Communicate between different Oracle sessions through a pipe in the RDBMS shared memory. This package allows you to "parallelize" program execution, and to execute host programs (C, shell, etc.) from within PL/SQL. DBMS_SESSION A programmatic interface to the SOL ALTER SESSION command set, including SET ROLE, SET_NLS, and RESET_PACKAGE, which re-instantiates all package states. DBMS_SNAPSHOT A programmatic interface through which you can manage snapshots and purge snapshot logs, You might use programs in this package to build scripts to automate maintenance of snapshots DBMS SQL My favorite built-in package, DBMS_SQL provides full support for dynamic SOL within PL/SQL. Dynamic SQL refers to SQL statements that are not pre-written into your programs. They are, instead, constructed at run time as character strings and then passed to the run time SQL engine for execution. You can even execute dynamic PL/SQL programs with DOMS SOL DBMS TRANSACTION A programmatic interface to several SQL transaction statements (e.g. SET TRANSACTION READ ONLY), and features used to manage distributed transactions. DBMS_UTILITY The "miscellaneous" package. Contains various useful utilities, such as FORMAT_CALL STACK, which returns the current stack of called modules, and GET_TIME, which can be used to calculate program performance down to the hundredth of a second. UTL_FILE Package that allows PL/SQL programs to read from and write to operating system files (PL/SQL Release 2.3 and above). Figure 1: Some Oracle server-side built-in packages.
